package com.xunyin.modules.meituan.service.mapper;


import com.xunyin.common.mapper.CoreMapper;
import com.xunyin.modules.meituan.domain.TMeituanStoremap;
import com.xunyin.modules.meituan.vo.TMeituanStoremapVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @Author xunyinyunshang  <3594419785@qq.com>
 * @date 2023-02-27
 */
@Repository
public interface TMeituanStoremapMapper extends CoreMapper<TMeituanStoremap> {


    @Select("<script> SELECT sto.*,sth.images from t_meituan_storemap sto " +
            " left join t_store sth on sth.id = sto.ePoiId " +
            " where sto.ePoiId = #{ePoiId} " +
            " and sto.isBind = #{isBind}</script>")
    List<TMeituanStoremapVo> meituanStoremapList(@Param("ePoiId") Integer ePoiId, @Param("isBind") Integer isBind);

}
